package com.zimu.api.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zimu.common.model.entity.UserInterfaceInfo;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 何文斌
* @description 针对表【user_interface_info(用户调用接口关系)】的数据库操作Mapper
* @createDate 2024-08-07 21:04:33
* @Entity com.yupi.project.model.entity.UserInterfaceInfoQueryRequest
*/
public interface UserInterfaceInfoMapper extends BaseMapper<UserInterfaceInfo> {
    @Select("select interfaceInfoId,SUM(totalNum) as totalNum from user_interface_info group by interfaceInfoId order by sum(totalNum) desc limit 3")
    List<UserInterfaceInfo> getTopInvokeNumInterfaceInfo();
}




